package com.hnhs.mapper;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

@Mapper
public interface CateProCountDao {

    //分类的总数据

    @Select("SELECT COUNT(*) FROM 202_category")
    public int categoryCount();
    //当天添加的分类
    @Select("SELECT COUNT(*) FROM 202_category  WHERE DATE(lastUpdateTime) = CURRENT_DATE")
    public int categoryToday();
    //统计商品的总数据
    @Select("SELECT COUNT(*) FROM 202_product")
    public int productCount();

    //当天添加的商品数量
    @Select("SELECT COUNT(*) FROM 202_product  WHERE DATE(lastUpdateTime) = CURRENT_DATE")
    public int productToday();


}
